package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.SysYyZhouhuiFixed;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * SysYyZhouhuiFixedMapper接口
 * 
 * @author SYF
 * @date 2025-06-10
 */
public interface SysYyZhouhuiFixedMapper 
{
    /**
     * 查询SysYyZhouhuiFixed
     * 
     * @param yYear SysYyZhouhuiFixed主键
     * @return SysYyZhouhuiFixed
     */
    public SysYyZhouhuiFixed selectSysYyZhouhuiFixedByYYear(String yYear);

    /**
     * 查询SysYyZhouhuiFixed列表
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return SysYyZhouhuiFixed集合
     */
    public List<SysYyZhouhuiFixed> selectSysYyZhouhuiFixedList(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 新增SysYyZhouhuiFixed
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return 结果
     */
    public int insertSysYyZhouhuiFixed(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 修改SysYyZhouhuiFixed
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return 结果
     */
    public int updateSysYyZhouhuiFixed(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 删除SysYyZhouhuiFixed
     * 
     * @param yYear SysYyZhouhuiFixed主键
     * @return 结果
     */
    public int deleteSysYyZhouhuiFixedByYYear(String yYear);

    /**
     * 批量删除SysYyZhouhuiFixed
     * 
     * @param yYears 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSysYyZhouhuiFixedByYYears(String[] yYears);

    public List<Map<String,Object>> selectZhStatu(@Param("year") String year);

    public List<Map<String,Object>> selectBigDepts(@Param("year") String year);

    public List<Map<String,Object>> selectSubDepts(@Param("year") String year);

    public List<Map<String,Object>> selectBrands(@Param("year") String year);

    public List<Map<String,Object>> selectYears(@Param("year") String year);

    public List<Map<String,Object>> selectSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectSubDeptSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectBrandSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectDetailSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectSubDeptTotalData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectBrandsTotalData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public Map<String,Object> selectCustomerSummary(@Param("month") String month);

    public Map<String,Object> selectCustomerSummaryByArea(@Param("month") String month, @Param("area") String area);

    public List<Map<String,Object>> selectCustomerAreasInfo();

    public List<Map<String,Object>> selectCustomerYearsInfo();

    public List<Map<String,Object>> selectCustomerYearsAscInfo();

    @Select("${sql}")
    public Map<String,Object> selectCustomerSummaryMap(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCustomerIncreaseSummary(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgQtyList(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgMoneyList(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgDetailList(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgTotalSummary(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectRisePriceSummary(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgVendorSummary(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectCgMonthSummary(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectWeeksInfo(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectSourcesInfo(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectPlatFansTypes(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectPlatFansYears(@Param("sql") String sql);

    @Select("${sql}")
    public List<Map<String,Object>> selectPlatFansData(@Param("sql") String sql);

    public List<Map<String,Object>> selectWeekIncreaseSummary(@Param("adtime") String adtime);

    public List<Map<String,Object>> selectWeekIncreaseSummaryByArea(@Param("area") String area,@Param("adtime") String adtime);

    public List<Map<String,Object>> selectLastWeekCustomers(@Param("year") String year);

    public List<Map<String,Object>> selectBigDeptsFg();

    public List<Map<String,Object>> selectFgAreaSummary();

    public List<Map<String,Object>> selectFgAreaSummaryByArea(@Param("area") String area);

    public List<Map<String,Object>> selectFgMonthBigDeptAndArea(@Param("year") String year,@Param("area") String area);

    public List<Map<String,Object>> selectFgMonthDepts(@Param("year") String year);

    public List<Map<String,Object>> selectFgMonthAreaSummaryByArea(@Param("year") String year,@Param("area") String area);

    public List<Map<String,Object>> selectFgMonthAreaSummary(@Param("year") String year);

    public List<Map<String,Object>> selectFgMonthData(@Param("year") String year,@Param("area") String area);

    public List<Map<String,Object>> selectCgCls(@Param("year") String year);

    public List<Map<String,Object>> selectCgIfwk(@Param("year") String year);
}
